CREATE TABLE [dbo].[OfferedCustomerExperience]
(
[OfferedCustomerExperienceKey] [uniqueidentifier] NOT NULL,
[OfferingKey] [uniqueidentifier] NOT NULL,
[OfferedCustomerExperienceGrade] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[OfferedCustomerExperienceGradeKey] [uniqueidentifier] NULL,
[OfferedCustomerExperienceDate] [datetime] NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[OfferedCustomerExperience] ADD CONSTRAINT [PK_OfferedCustomerExperience_OfferedCustomerExperienceKey] PRIMARY KEY CLUSTERED ([OfferedCustomerExperienceKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_OfferedCustomerExperience_OfferedCustomerExperienceGradeKey] ON [dbo].[OfferedCustomerExperience] ([OfferedCustomerExperienceGradeKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_OfferedCustomerExperience_OfferingKey] ON [dbo].[OfferedCustomerExperience] ([OfferingKey]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[OfferedCustomerExperience] ADD CONSTRAINT [FK_OfferedCustomerExperience_CustomerExperience] FOREIGN KEY ([OfferedCustomerExperienceKey]) REFERENCES [dbo].[CustomerExperience] ([CustomerExperienceKey])
GO
ALTER TABLE [dbo].[OfferedCustomerExperience] ADD CONSTRAINT [FK_OfferedCustomerExperience_GradeRef] FOREIGN KEY ([OfferedCustomerExperienceGradeKey]) REFERENCES [dbo].[GradeRef] ([GradeKey])
GO
ALTER TABLE [dbo].[OfferedCustomerExperience] ADD CONSTRAINT [FK_OfferedCustomerExperience_Offering] FOREIGN KEY ([OfferingKey]) REFERENCES [dbo].[Offering] ([OfferingKey])
GO